using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class DMS028_SBL_VIEWManagerBase
    {
        public DMS028_SBL_VIEWManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity Insert(DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity Update(DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.Update(obj);             
        }
 
 
        public DMS028_SBL_VIEWEntity Delete(DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.Delete(obj);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByORDER_NO (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByORDER_NO (string ORDER_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPART_NO (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PART_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NO 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPART_NO (string PART_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NO = PART_NO;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PART_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByLINE_NO (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LINE_NO 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByLINE_NO (string LINE_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_NO = LINE_NO;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByWH_CODE (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByWH_CODE (string WH_CODE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteBySTATUS (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"STATUS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STATUS 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteBySTATUS (string STATUS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"STATUS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByBO_FLAG (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_FLAG 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByBO_FLAG (string BO_FLAG )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_FLAG = BO_FLAG;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByQTY (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByQTY (double QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.QTY = QTY;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPRICE (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PRICE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PRICE 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPRICE (double PRICE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE = PRICE;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PRICE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByALL_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ALL_QTY 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByALL_QTY (double ALL_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ALL_QTY = ALL_QTY;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByBO_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_QTY 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByBO_QTY (double BO_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_QTY = BO_QTY;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByDLV_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DLV_QTY 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByDLV_QTY (double DLV_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DLV_QTY = DLV_QTY;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCANCEL_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CANCEL_QTY 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCANCEL_QTY (double CANCEL_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByDISCOUNT_RATE (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_RATE 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByDISCOUNT_RATE (double DISCOUNT_RATE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByDISCOUNT_AMNT (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_AMNT 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByDISCOUNT_AMNT (double DISCOUNT_AMNT )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByVAT_ID (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien VAT_ID 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByVAT_ID (string VAT_ID )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_ID = VAT_ID;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByACTFLG (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByACTFLG (string ACTFLG )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDUSR (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDUSR (string CTDUSR )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDWKS (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDWKS (string CTDWKS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDPGM (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDPGM (string CTDPGM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDDTM (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByCTDDTM (DateTime CTDDTM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByMDFUSR (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByMDFUSR (string MDFUSR )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByMDFWKS (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByMDFWKS (string MDFWKS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByMDFPGM (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByMDFPGM (string MDFPGM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByLSTMDF (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByLSTMDF (DateTime LSTMDF )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien VAT_RATE duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByVAT_RATE (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"VAT_RATE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien VAT_RATE 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByVAT_RATE (double VAT_RATE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_RATE = VAT_RATE;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"VAT_RATE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NAME_V duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPART_NAME_V (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PART_NAME_V");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NAME_V 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPART_NAME_V (string PART_NAME_V )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NAME_V = PART_NAME_V;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PART_NAME_V");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LINE_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByLINE_TOTAL (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LINE_TOTAL");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LINE_TOTAL 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByLINE_TOTAL (double LINE_TOTAL )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_TOTAL = LINE_TOTAL;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LINE_TOTAL");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PRICE_AFTER_DISCOUNT duoc set trong object
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPRICE_AFTER_DISCOUNT (DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PRICE_AFTER_DISCOUNT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PRICE_AFTER_DISCOUNT 
        /// </summary>
        /// <returns>DMS028_SBL_VIEWEntity</returns>
        public DMS028_SBL_VIEWEntity DeleteByPRICE_AFTER_DISCOUNT (double PRICE_AFTER_DISCOUNT )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE_AFTER_DISCOUNT = PRICE_AFTER_DISCOUNT;  
            return (DMS028_SBL_VIEWEntity)Adapter.DeleteByField(obj,"PRICE_AFTER_DISCOUNT");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public DMS028_SBL_VIEWEntity Select(DMS028_SBL_VIEWEntity obj)
        { 
            return (DMS028_SBL_VIEWEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS028_SBL_VIEWEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS028_SBL_VIEWEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new DMS028_SBL_VIEWEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new DMS028_SBL_VIEWEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS028_SBL_VIEWEntity> SelectAllLST()
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS028_SBL_VIEWEntity()),new DMS028_SBL_VIEWEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS028_SBL_VIEWEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS028_SBL_VIEWEntity(),option),new DMS028_SBL_VIEWEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ORDER_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByORDER_NOLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByORDER_NOLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ORDER_NO",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (string ORDER_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return Adapter.SelectByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (string ORDER_NO, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return Adapter.SelectByField(obj,"ORDER_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByORDER_NOLST (string ORDER_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByORDER_NOLST (string ORDER_NO, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"PART_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PART_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NOLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NOLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PART_NO",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (string PART_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NO = PART_NO;  
            return Adapter.SelectByField(obj,"PART_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (string PART_NO, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NO = PART_NO;  
            return Adapter.SelectByField(obj,"PART_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NOLST (string PART_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NO = PART_NO;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NOLST (string PART_NO, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NO = PART_NO;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_NOLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_NO"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_NOLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"LINE_NO",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (string LINE_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_NO = LINE_NO;  
            return Adapter.SelectByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (string LINE_NO, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_NO = LINE_NO;  
            return Adapter.SelectByField(obj,"LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_NOLST (string LINE_NO )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_NO = LINE_NO;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_NO"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_NOLST (string LINE_NO, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_NO = LINE_NO;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_NO",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByWH_CODELST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByWH_CODELST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"WH_CODE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByWH_CODELST (string WH_CODE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByWH_CODELST (string WH_CODE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"STATUS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"STATUS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectBySTATUSLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectBySTATUSLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"STATUS",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (string STATUS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return Adapter.SelectByField(obj,"STATUS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (string STATUS, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return Adapter.SelectByField(obj,"STATUS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectBySTATUSLST (string STATUS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectBySTATUSLST (string STATUS, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"BO_FLAG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_FLAGLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_FLAG"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_FLAGLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"BO_FLAG",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (string BO_FLAG )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_FLAG = BO_FLAG;  
            return Adapter.SelectByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (string BO_FLAG, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_FLAG = BO_FLAG;  
            return Adapter.SelectByField(obj,"BO_FLAG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_FLAGLST (string BO_FLAG )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_FLAG = BO_FLAG;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_FLAG"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_FLAGLST (string BO_FLAG, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_FLAG = BO_FLAG;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_FLAG",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByQTYLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByQTYLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (double QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (double QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByQTYLST (double QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.QTY = QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByQTYLST (double QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.QTY = QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"PRICE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PRICE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICELST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICELST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PRICE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (double PRICE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE = PRICE;  
            return Adapter.SelectByField(obj,"PRICE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (double PRICE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE = PRICE;  
            return Adapter.SelectByField(obj,"PRICE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICELST (double PRICE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE = PRICE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICELST (double PRICE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE = PRICE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ALL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByALL_QTYLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ALL_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByALL_QTYLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ALL_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (double ALL_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ALL_QTY = ALL_QTY;  
            return Adapter.SelectByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (double ALL_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ALL_QTY = ALL_QTY;  
            return Adapter.SelectByField(obj,"ALL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByALL_QTYLST (double ALL_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ALL_QTY = ALL_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ALL_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByALL_QTYLST (double ALL_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ALL_QTY = ALL_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ALL_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"BO_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_QTYLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_QTYLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"BO_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (double BO_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_QTY = BO_QTY;  
            return Adapter.SelectByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (double BO_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_QTY = BO_QTY;  
            return Adapter.SelectByField(obj,"BO_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_QTYLST (double BO_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_QTY = BO_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByBO_QTYLST (double BO_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.BO_QTY = BO_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DLV_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDLV_QTYLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DLV_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDLV_QTYLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DLV_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (double DLV_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DLV_QTY = DLV_QTY;  
            return Adapter.SelectByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (double DLV_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DLV_QTY = DLV_QTY;  
            return Adapter.SelectByField(obj,"DLV_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDLV_QTYLST (double DLV_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DLV_QTY = DLV_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DLV_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDLV_QTYLST (double DLV_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DLV_QTY = DLV_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DLV_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CANCEL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCANCEL_QTYLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CANCEL_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCANCEL_QTYLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CANCEL_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (double CANCEL_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return Adapter.SelectByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (double CANCEL_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return Adapter.SelectByField(obj,"CANCEL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCANCEL_QTYLST (double CANCEL_QTY )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CANCEL_QTY"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCANCEL_QTYLST (double CANCEL_QTY, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CANCEL_QTY",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_RATE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_RATELST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_RATE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_RATELST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DISCOUNT_RATE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (double DISCOUNT_RATE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return Adapter.SelectByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (double DISCOUNT_RATE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return Adapter.SelectByField(obj,"DISCOUNT_RATE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_RATELST (double DISCOUNT_RATE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_RATE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_RATELST (double DISCOUNT_RATE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_RATE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_AMNTLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_AMNT"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_AMNTLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DISCOUNT_AMNT",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (double DISCOUNT_AMNT )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (double DISCOUNT_AMNT, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_AMNTLST (double DISCOUNT_AMNT )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_AMNT"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByDISCOUNT_AMNTLST (double DISCOUNT_AMNT, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_AMNT",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"VAT_ID",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_IDLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_ID"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_IDLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"VAT_ID",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (string VAT_ID )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_ID = VAT_ID;  
            return Adapter.SelectByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (string VAT_ID, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_ID = VAT_ID;  
            return Adapter.SelectByField(obj,"VAT_ID",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_IDLST (string VAT_ID )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_ID = VAT_ID;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_ID"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_IDLST (string VAT_ID, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_ID = VAT_ID;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_ID",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByACTFLGLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByACTFLGLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ACTFLG",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByACTFLGLST (string ACTFLG )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByACTFLGLST (string ACTFLG, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDUSRLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDUSRLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDUSR",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDUSRLST (string CTDUSR )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDUSRLST (string CTDUSR, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDWKSLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDWKSLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDWKS",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDWKSLST (string CTDWKS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDWKSLST (string CTDWKS, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDPGMLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDPGMLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDPGM",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDPGMLST (string CTDPGM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDPGMLST (string CTDPGM, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDDTMLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDDTMLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDDTM",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDDTMLST (DateTime CTDDTM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByCTDDTMLST (DateTime CTDDTM, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFUSRLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFUSRLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFUSR",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFUSRLST (string MDFUSR )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFUSRLST (string MDFUSR, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFWKSLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFWKSLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFWKS",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFWKSLST (string MDFWKS )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFWKSLST (string MDFWKS, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFPGMLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFPGMLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFPGM",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFPGMLST (string MDFPGM )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByMDFPGMLST (string MDFPGM, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLSTMDFLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLSTMDFLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"LSTMDF",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLSTMDFLST (DateTime LSTMDF )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLSTMDFLST (DateTime LSTMDF, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_RATE (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"VAT_RATE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_RATE (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"VAT_RATE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_RATELST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_RATE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_RATELST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"VAT_RATE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_RATE (double VAT_RATE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_RATE = VAT_RATE;  
            return Adapter.SelectByField(obj,"VAT_RATE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_RATE (double VAT_RATE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_RATE = VAT_RATE;  
            return Adapter.SelectByField(obj,"VAT_RATE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_RATELST (double VAT_RATE )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_RATE = VAT_RATE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_RATE"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByVAT_RATELST (double VAT_RATE, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.VAT_RATE = VAT_RATE;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_RATE",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NAME_V (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"PART_NAME_V");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NAME_V (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PART_NAME_V",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NAME_VLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NAME_V"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NAME_VLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PART_NAME_V",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NAME_V (string PART_NAME_V )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NAME_V = PART_NAME_V;  
            return Adapter.SelectByField(obj,"PART_NAME_V");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NAME_V (string PART_NAME_V, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NAME_V = PART_NAME_V;  
            return Adapter.SelectByField(obj,"PART_NAME_V",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NAME_VLST (string PART_NAME_V )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NAME_V = PART_NAME_V;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NAME_V"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NAME_V duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPART_NAME_VLST (string PART_NAME_V, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PART_NAME_V = PART_NAME_V;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NAME_V",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_TOTAL (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"LINE_TOTAL");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_TOTAL (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"LINE_TOTAL",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_TOTALLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_TOTAL"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_TOTALLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"LINE_TOTAL",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_TOTAL (double LINE_TOTAL )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_TOTAL = LINE_TOTAL;  
            return Adapter.SelectByField(obj,"LINE_TOTAL");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_TOTAL (double LINE_TOTAL, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_TOTAL = LINE_TOTAL;  
            return Adapter.SelectByField(obj,"LINE_TOTAL",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_TOTALLST (double LINE_TOTAL )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_TOTAL = LINE_TOTAL;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_TOTAL"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByLINE_TOTALLST (double LINE_TOTAL, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.LINE_TOTAL = LINE_TOTAL;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_TOTAL",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE_AFTER_DISCOUNT (DMS028_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE_AFTER_DISCOUNT (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICE_AFTER_DISCOUNTLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICE_AFTER_DISCOUNTLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE_AFTER_DISCOUNT (double PRICE_AFTER_DISCOUNT )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE_AFTER_DISCOUNT = PRICE_AFTER_DISCOUNT;  
            return Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE_AFTER_DISCOUNT (double PRICE_AFTER_DISCOUNT, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE_AFTER_DISCOUNT = PRICE_AFTER_DISCOUNT;  
            return Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICE_AFTER_DISCOUNTLST (double PRICE_AFTER_DISCOUNT )
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE_AFTER_DISCOUNT = PRICE_AFTER_DISCOUNT;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT"),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE_AFTER_DISCOUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028_SBL_VIEWEntity> SelectByPRICE_AFTER_DISCOUNTLST (double PRICE_AFTER_DISCOUNT, SelectOptions option)
        { 
            DMS028_SBL_VIEWEntity obj = new DMS028_SBL_VIEWEntity();
            obj.PRICE_AFTER_DISCOUNT = PRICE_AFTER_DISCOUNT;  
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE_AFTER_DISCOUNT",option),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectWithConditionLST (DMS028_SBL_VIEWEntity obj)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new DMS028_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS028_SBL_VIEWEntity></returns>
        public List<DMS028_SBL_VIEWEntity> SelectWithConditionLST (DMS028_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS028_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new DMS028_SBL_VIEWEntity());
        }

}
}
